Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnLineItem(TR_LTM_SLS_RTN) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | SaleReturnLineItem(TR_LTM_SLS_RTN) |
SalesTaxSequenceNumber (PK) | A sequentially assigned number used to ensure a unique identity for SaleReturnTaxLineItem instances. | IC_SLS_TX_SQN_NMB | LineNumber | smallint | |
TaxGroupRuleID (FK) | System assigned unique identifier for the TaxGroupRule. | ID_RU_TX_GRP | Identity | integer | TaxGroupRule(RU_TX_GP) |
UsageCode (FK) | Retailer defined mnemonic code identifying the CustomerIntendedUsage. Eg: EatIn, TakeOut, consumption, resale | CD_TYP_TX_INTD_USE | Code4 | char(4) | TaxIntendedUsageType(CO_TYP_TX_INTD_USE) |
ReasonCode (FK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
TaxIncludedInPricesFlag | A flag denoting that all applicable taxes are included in the prices for this line item, and that therefore this SaleReturnTaxLineItem is merely a summary of those taxes, | FL_TX_INCL | Flag | integer | |
TaxAtSourceFlag | A flag denoting that the goods being sold and shipped have been taxed according to the TaxAuthorityShippingRule. | FL_TX_SRC | Flag | integer | |
TaxableAmount | The monetary amount for which tax is applicable. | MO_TXBL_RTN_SLS | Money | decimal(16,5) | |
TaxablePercent | The percentage of the taxable amount that is liable for tax. Usually this is 100% but where an aggregate item contains taxed and non-taxed goods this value may be less than 100%. | PE_TXBL | Percent | decimal(7,4) | |
TaxPercent | The percentage of the taxable portion of the taxable amount that is being collected as tax by this LineItem. | PE_TX | Percent | decimal(7,4) | |
TaxAmount | The monetary value tax that is being collected by this LineItem. | MO_TX_RTN_SLS | Money | decimal(16,5) | |